package app.util;

public class UserStrings {
    public static String DBTableCreateStatement =
            "create table if not exists records(" +
            "id integer primary key autoincrement not null, " +
            "bookname string not null, " +
            "bookcategory string not null, " +
            "readdate string not null);";
    public static String DBTableSelectDate = "select * from records where readdate = ? order by id;";
    public static String DBTableSelectDateCount = "select count(*) from records where readdate = ? order by id;";
    public static String DBTableSelectDateRange = "select * from records where readdate >= ? and readdate <= ? order by readdate;";
    public static String DBTableSelectDateRangeCount = "select count(*) from records where readdate >= ? and readdate <= ? order by readdate;";
    public static String DBTableInsert = "insert into records values(null, ?, ?, ?);";
    public static String DBTableDelete = "delete from records where id = ? and readdate = ?;";
    public static String DBFileString = "jdbc:sqlite:" + Path.Location.getRecordsDBLocation();
}
